DBlookup using multiple key

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: DBlookup using multiple key

Feedback Type: Question

Product Area: Database

Technical Area: Functionality

Platform: Windows XP client

Release: 8.5

Reproducible: -Reproducibility-

Hi,

I am trying this simple thing but I am lost somewhere. I don't know what I am missing. I am trying to do Dblookup to fetch values from the third column in a view based on the first two coulmn values.

I have 3 fields in a form. For the first field, I am doing Dblookup from the first column of the view. For the second field, I am doing Dblookup from the second column of the view based on the values selected in first field.

Now for the 3rd field, I have to get the value from the third column of the view based on the values selected in first 2 fields. In sort, I have to do dblookup based on 2 keys rather than one. I was trying giving values selected in first 2 fields as a key fro 3rd field separated by colon but its not working.

Thanks so much in advance
L TYAGI

Feedback number WEBB7W8NAM created by ~Tony Loptumikonyoopsi on 09/25/2009

Status: Open
Comments: